﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TFBSUniversityDataSet" targetNamespace="http://tempuri.org/TFBSUniversityDataSet.xsd" xmlns:mstns="http://tempuri.org/TFBSUniversityDataSet.xsd" xmlns="http://tempuri.org/TFBSUniversityDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="TFBSUniversityConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TFBSUniversityConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Database_Ass1_2013.Properties.Settings.GlobalReference.Default.TFBSUniversityConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BILLTableAdapter" GeneratorDataComponentClassName="BILLTableAdapter" Name="BILL" UserDataComponentName="BILLTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectName="TFBSUniversity.BILL" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tfbsuniversity`.`bill` WHERE ((`BillId` = @Original_BillId) AND (`DateTime` = @Original_DateTime) AND (`OdometerReading` = @Original_OdometerReading) AND (`PaymentMethod` = @Original_PaymentMethod) AND ((@IsNull_CreditCardNo = 1 AND `CreditCardNo` IS NULL) OR (`CreditCardNo` = @Original_CreditCardNo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BillId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BillId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PaymentMethod" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentMethod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreditCardNo" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tfbsuniversity`.`bill` (`DateTime`, `OdometerReading`, `PaymentMethod`, `CreditCardNo`) VALUES (@DateTime, @OdometerReading, @PaymentMethod, @CreditCardNo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PaymentMethod" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentMethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `BillId`, `DateTime`, `OdometerReading`, `PaymentMethod`, `CreditCardNo` FROM `BILL`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tfbsuniversity`.`bill` SET `DateTime` = @DateTime, `OdometerReading` = @OdometerReading, `PaymentMethod` = @PaymentMethod, `CreditCardNo` = @CreditCardNo WHERE ((`BillId` = @Original_BillId) AND (`DateTime` = @Original_DateTime) AND (`OdometerReading` = @Original_OdometerReading) AND (`PaymentMethod` = @Original_PaymentMethod) AND ((@IsNull_CreditCardNo = 1 AND `CreditCardNo` IS NULL) OR (`CreditCardNo` = @Original_CreditCardNo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PaymentMethod" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentMethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BillId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BillId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PaymentMethod" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentMethod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreditCardNo" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BillId" DataSetColumn="BillId" />
              <Mapping SourceColumn="DateTime" DataSetColumn="DateTime" />
              <Mapping SourceColumn="OdometerReading" DataSetColumn="OdometerReading" />
              <Mapping SourceColumn="PaymentMethod" DataSetColumn="PaymentMethod" />
              <Mapping SourceColumn="CreditCardNo" DataSetColumn="CreditCardNo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BOOKINGTableAdapter" GeneratorDataComponentClassName="BOOKINGTableAdapter" Name="BOOKING" UserDataComponentName="BOOKINGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillReservations" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetReservations" GeneratorSourceName="FillReservations" GetMethodModifier="Public" GetMethodName="GetReservations" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetReservations" UserSourceName="FillReservations">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        b.BookingId AS `Booking ID`, CONCAT(m.FirstName, ' ', m.Surname) AS `Memb Name`, b.DepartureDate AS `Departure Date`, 
                         b.DestinationAddress AS `Dest Address`, b.DestinationPostcode AS `Dest Postcode`, CONCAT(e.FirstName, ' ', e.Surname) AS `Clerk Name`, d.Name AS Department, 
                         CONCAT(v.Model, ' - ', v.RegNo) AS Vehicle
FROM            MEMBER m INNER JOIN
                         DEPARTMENT d ON m.DEPARTMENT_DepartmentId = d.DepartmentId INNER JOIN
                         BOOKING b ON b.MEMBER_MemberId = m.MemberId INNER JOIN
                         VEHICLE v ON v.VahicleId = b.VEHICLE_VahicleId INNER JOIN
                         EMPLOYEE e ON e.EmployeeId = b.EMPLOYEE_EmployeeId</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Booking ID" DataSetColumn="Booking ID" />
              <Mapping SourceColumn="Departure Date" DataSetColumn="Departure Date" />
              <Mapping SourceColumn="Memb Name" DataSetColumn="Memb Name" />
              <Mapping SourceColumn="Department" DataSetColumn="Department" />
              <Mapping SourceColumn="Vehicle" DataSetColumn="Vehicle" />
              <Mapping SourceColumn="Dest Address" DataSetColumn="Dest Address" />
              <Mapping SourceColumn="Dest Postcode" DataSetColumn="Dest Postcode" />
              <Mapping SourceColumn="Clerk Name" DataSetColumn="Clerk Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CHECKOUTTableAdapter" GeneratorDataComponentClassName="CHECKOUTTableAdapter" Name="CHECKOUT" UserDataComponentName="CHECKOUTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectName="TFBSUniversity.CHECKOUT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tfbsuniversity`.`checkout` WHERE ((`CheckOutId` = @Original_CheckOutId) AND (`EMPLOYEE_EmployeeId` = @Original_EMPLOYEE_EmployeeId) AND (`OdometerReading` = @Original_OdometerReading) AND (`DateStart` = @Original_DateStart) AND (`DateEnd` = @Original_DateEnd) AND ((@IsNull_FuelPurchasedLitres = 1 AND `FuelPurchasedLitres` IS NULL) OR (`FuelPurchasedLitres` = @Original_FuelPurchasedLitres)) AND ((@IsNull_CreditCardNo = 1 AND `CreditCardNo` IS NULL) OR (`CreditCardNo` = @Original_CreditCardNo)) AND (`BILL_BillId` = @Original_BILL_BillId) AND (`BOOKING_BookingId` = @Original_BOOKING_BookingId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CheckOutId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="CheckOutId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateStart" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateEnd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FuelPurchasedLitres" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="FuelPurchasedLitres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FuelPurchasedLitres" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="FuelPurchasedLitres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreditCardNo" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BILL_BillId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BILL_BillId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BOOKING_BookingId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BOOKING_BookingId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tfbsuniversity`.`checkout` (`EMPLOYEE_EmployeeId`, `OdometerReading`, `DateStart`, `DateEnd`, `FuelPurchasedLitres`, `CreditCardNo`, `BILL_BillId`, `BOOKING_BookingId`) VALUES (@EMPLOYEE_EmployeeId, @OdometerReading, @DateStart, @DateEnd, @FuelPurchasedLitres, @CreditCardNo, @BILL_BillId, @BOOKING_BookingId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateStart" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateEnd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FuelPurchasedLitres" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="FuelPurchasedLitres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BILL_BillId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BILL_BillId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BOOKING_BookingId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BOOKING_BookingId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `CheckOutId`, `EMPLOYEE_EmployeeId`, `OdometerReading`, `DateStart`, `DateEnd`, `FuelPurchasedLitres`, `CreditCardNo`, `BILL_BillId`, `BOOKING_BookingId` FROM `CHECKOUT`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tfbsuniversity`.`checkout` SET `EMPLOYEE_EmployeeId` = @EMPLOYEE_EmployeeId, `OdometerReading` = @OdometerReading, `DateStart` = @DateStart, `DateEnd` = @DateEnd, `FuelPurchasedLitres` = @FuelPurchasedLitres, `CreditCardNo` = @CreditCardNo, `BILL_BillId` = @BILL_BillId, `BOOKING_BookingId` = @BOOKING_BookingId WHERE ((`CheckOutId` = @Original_CheckOutId) AND (`EMPLOYEE_EmployeeId` = @Original_EMPLOYEE_EmployeeId) AND (`OdometerReading` = @Original_OdometerReading) AND (`DateStart` = @Original_DateStart) AND (`DateEnd` = @Original_DateEnd) AND ((@IsNull_FuelPurchasedLitres = 1 AND `FuelPurchasedLitres` IS NULL) OR (`FuelPurchasedLitres` = @Original_FuelPurchasedLitres)) AND ((@IsNull_CreditCardNo = 1 AND `CreditCardNo` IS NULL) OR (`CreditCardNo` = @Original_CreditCardNo)) AND (`BILL_BillId` = @Original_BILL_BillId) AND (`BOOKING_BookingId` = @Original_BOOKING_BookingId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateStart" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateEnd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FuelPurchasedLitres" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="FuelPurchasedLitres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BILL_BillId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BILL_BillId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BOOKING_BookingId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BOOKING_BookingId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CheckOutId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="CheckOutId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_OdometerReading" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="OdometerReading" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateStart" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateEnd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FuelPurchasedLitres" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="FuelPurchasedLitres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FuelPurchasedLitres" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="FuelPurchasedLitres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreditCardNo" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CreditCardNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CreditCardNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BILL_BillId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BILL_BillId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BOOKING_BookingId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="BOOKING_BookingId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CheckOutId" DataSetColumn="CheckOutId" />
              <Mapping SourceColumn="EMPLOYEE_EmployeeId" DataSetColumn="EMPLOYEE_EmployeeId" />
              <Mapping SourceColumn="OdometerReading" DataSetColumn="OdometerReading" />
              <Mapping SourceColumn="DateStart" DataSetColumn="DateStart" />
              <Mapping SourceColumn="DateEnd" DataSetColumn="DateEnd" />
              <Mapping SourceColumn="FuelPurchasedLitres" DataSetColumn="FuelPurchasedLitres" />
              <Mapping SourceColumn="CreditCardNo" DataSetColumn="CreditCardNo" />
              <Mapping SourceColumn="BILL_BillId" DataSetColumn="BILL_BillId" />
              <Mapping SourceColumn="BOOKING_BookingId" DataSetColumn="BOOKING_BookingId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DEPARTMENTTableAdapter" GeneratorDataComponentClassName="DEPARTMENTTableAdapter" Name="DEPARTMENT" UserDataComponentName="DEPARTMENTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectName="TFBSUniversity.DEPARTMENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tfbsuniversity`.`department` WHERE ((`DepartmentId` = @Original_DepartmentId) AND (`Name` = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="DepartmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tfbsuniversity`.`department` (`Name`) VALUES (@Name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `DepartmentId`, `Name` FROM `DEPARTMENT`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tfbsuniversity`.`department` SET `Name` = @Name WHERE ((`DepartmentId` = @Original_DepartmentId) AND (`Name` = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="DepartmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DepartmentId" DataSetColumn="DepartmentId" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EMPLOYEETableAdapter" GeneratorDataComponentClassName="EMPLOYEETableAdapter" Name="EMPLOYEE" UserDataComponentName="EMPLOYEETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillAllEployees" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetAllEmployees" GeneratorSourceName="FillAllEployees" GetMethodModifier="Public" GetMethodName="GetAllEmployees" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetAllEmployees" UserSourceName="FillAllEployees">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        e.EmployeeId AS `Id`, 
                     e.FirstName AS `Firstname`, 
                     e.Surname, 
                     e.EmailAddress AS `Email address`, 
                     e.TelNo AS `Contact number`,
                     e.Role, d.Name AS `Department`

FROM            `EMPLOYEE` e INNER JOIN
                         `DEPARTMENT` d ON e.fkDepartmentId = d.DepartmentId
ORDER BY Id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Firstname" DataSetColumn="Firstname" />
              <Mapping SourceColumn="Email address" DataSetColumn="Email address" />
              <Mapping SourceColumn="Contact number" DataSetColumn="Contact number" />
              <Mapping SourceColumn="Department" DataSetColumn="Department" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INVENTORYTableAdapter" GeneratorDataComponentClassName="INVENTORYTableAdapter" Name="INVENTORY" UserDataComponentName="INVENTORYTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectName="TFBSUniversity.INVENTORY" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tfbsuniversity`.`inventory` WHERE ((`PartId` = @Original_PartId) AND (`Name` = @Original_Name) AND (`Qty` = @Original_Qty) AND (`LastOrder` = @Original_LastOrder))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PartId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="PartId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_LastOrder" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tfbsuniversity`.`inventory` (`Name`, `Qty`, `LastOrder`) VALUES (@Name, @Qty, @LastOrder)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@LastOrder" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `PartId`, `Name`, `Qty`, `LastOrder` FROM `INVENTORY`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tfbsuniversity`.`inventory` SET `Name` = @Name, `Qty` = @Qty, `LastOrder` = @LastOrder WHERE ((`PartId` = @Original_PartId) AND (`Name` = @Original_Name) AND (`Qty` = @Original_Qty) AND (`LastOrder` = @Original_LastOrder))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@LastOrder" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PartId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="PartId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_LastOrder" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PartId" DataSetColumn="PartId" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Qty" DataSetColumn="Qty" />
              <Mapping SourceColumn="LastOrder" DataSetColumn="LastOrder" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MAINTENANCETableAdapter" GeneratorDataComponentClassName="MAINTENANCETableAdapter" Name="MAINTENANCE" UserDataComponentName="MAINTENANCETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectName="TFBSUniversity.MAINTENANCE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tfbsuniversity`.`maintenance` WHERE ((`MaintenanceId` = @Original_MaintenanceId) AND (`Description` = @Original_Description) AND (`StartDate` = @Original_StartDate) AND (`EndDate` = @Original_EndDate) AND (`VEHICLE_VahicleId` = @Original_VEHICLE_VahicleId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaintenanceId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="MaintenanceId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VEHICLE_VahicleId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="VEHICLE_VahicleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tfbsuniversity`.`maintenance` (`Description`, `StartDate`, `EndDate`, `VEHICLE_VahicleId`) VALUES (@Description, @StartDate, @EndDate, @VEHICLE_VahicleId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VEHICLE_VahicleId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="VEHICLE_VahicleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `MaintenanceId`, `Description`, `StartDate`, `EndDate`, `VEHICLE_VahicleId` FROM `MAINTENANCE`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tfbsuniversity`.`maintenance` SET `Description` = @Description, `StartDate` = @StartDate, `EndDate` = @EndDate, `VEHICLE_VahicleId` = @VEHICLE_VahicleId WHERE ((`MaintenanceId` = @Original_MaintenanceId) AND (`Description` = @Original_Description) AND (`StartDate` = @Original_StartDate) AND (`EndDate` = @Original_EndDate) AND (`VEHICLE_VahicleId` = @Original_VEHICLE_VahicleId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VEHICLE_VahicleId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="VEHICLE_VahicleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaintenanceId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="MaintenanceId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VEHICLE_VahicleId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="VEHICLE_VahicleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaintenanceId" DataSetColumn="MaintenanceId" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="VEHICLE_VahicleId" DataSetColumn="VEHICLE_VahicleId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MAINTENANCE_DETAILSTableAdapter" GeneratorDataComponentClassName="MAINTENANCE_DETAILSTableAdapter" Name="MAINTENANCE_DETAILS" UserDataComponentName="MAINTENANCE_DETAILSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectName="TFBSUniversity.MAINTENANCE_DETAILS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tfbsuniversity`.`maintenance_details` WHERE ((`MAINTENANCE_MaintenanceId` = @Original_MAINTENANCE_MaintenanceId) AND ((@IsNull_ItemPerformed = 1 AND `ItemPerformed` IS NULL) OR (`ItemPerformed` = @Original_ItemPerformed)) AND (`INVENTORY_PartId` = @Original_INVENTORY_PartId) AND (`EMPLOYEE_EmployeeId` = @Original_EMPLOYEE_EmployeeId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MAINTENANCE_MaintenanceId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="MAINTENANCE_MaintenanceId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ItemPerformed" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ItemPerformed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ItemPerformed" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ItemPerformed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INVENTORY_PartId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="INVENTORY_PartId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tfbsuniversity`.`maintenance_details` (`MAINTENANCE_MaintenanceId`, `ItemPerformed`, `INVENTORY_PartId`, `EMPLOYEE_EmployeeId`) VALUES (@MAINTENANCE_MaintenanceId, @ItemPerformed, @INVENTORY_PartId, @EMPLOYEE_EmployeeId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MAINTENANCE_MaintenanceId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="MAINTENANCE_MaintenanceId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ItemPerformed" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ItemPerformed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INVENTORY_PartId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="INVENTORY_PartId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `MAINTENANCE_MaintenanceId`, `ItemPerformed`, `INVENTORY_PartId`, `EMPLOYEE_EmployeeId` FROM `MAINTENANCE_DETAILS`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tfbsuniversity`.`maintenance_details` SET `MAINTENANCE_MaintenanceId` = @MAINTENANCE_MaintenanceId, `ItemPerformed` = @ItemPerformed, `INVENTORY_PartId` = @INVENTORY_PartId, `EMPLOYEE_EmployeeId` = @EMPLOYEE_EmployeeId WHERE ((`MAINTENANCE_MaintenanceId` = @Original_MAINTENANCE_MaintenanceId) AND ((@IsNull_ItemPerformed = 1 AND `ItemPerformed` IS NULL) OR (`ItemPerformed` = @Original_ItemPerformed)) AND (`INVENTORY_PartId` = @Original_INVENTORY_PartId) AND (`EMPLOYEE_EmployeeId` = @Original_EMPLOYEE_EmployeeId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MAINTENANCE_MaintenanceId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="MAINTENANCE_MaintenanceId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ItemPerformed" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ItemPerformed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INVENTORY_PartId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="INVENTORY_PartId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MAINTENANCE_MaintenanceId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="MAINTENANCE_MaintenanceId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ItemPerformed" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ItemPerformed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ItemPerformed" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ItemPerformed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INVENTORY_PartId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="INVENTORY_PartId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EMPLOYEE_EmployeeId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="EMPLOYEE_EmployeeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MAINTENANCE_MaintenanceId" DataSetColumn="MAINTENANCE_MaintenanceId" />
              <Mapping SourceColumn="ItemPerformed" DataSetColumn="ItemPerformed" />
              <Mapping SourceColumn="INVENTORY_PartId" DataSetColumn="INVENTORY_PartId" />
              <Mapping SourceColumn="EMPLOYEE_EmployeeId" DataSetColumn="EMPLOYEE_EmployeeId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VEHICLETableAdapter" GeneratorDataComponentClassName="VEHICLETableAdapter" Name="VEHICLE" UserDataComponentName="VEHICLETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TFBSUniversityConnectionString (Settings)" DbObjectName="TFBSUniversity.VEHICLE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAll" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetAll" GeneratorSourceName="FillAll" GetMethodModifier="Public" GetMethodName="GetAll" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetAll" UserSourceName="FillAll">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DISTINCT VahicleId, Model, RegNo, MileAge, LitresFuel, MileAgeRate
FROM            VEHICLE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="VahicleId" DataSetColumn="VahicleId" />
              <Mapping SourceColumn="RegNo" DataSetColumn="RegNo" />
              <Mapping SourceColumn="MileAge" DataSetColumn="MileAge" />
              <Mapping SourceColumn="LitresFuel" DataSetColumn="LitresFuel" />
              <Mapping SourceColumn="MileAgeRate" DataSetColumn="MileAgeRate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TFBSUniversityDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="TFBSUniversityDataSet" msprop:Generator_UserDSName="TFBSUniversityDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="BILL" msprop:Generator_TableClassName="BILLDataTable" msprop:Generator_TableVarName="tableBILL" msprop:Generator_TablePropName="BILL" msprop:Generator_RowDeletingName="BILLRowDeleting" msprop:Generator_RowChangingName="BILLRowChanging" msprop:Generator_RowEvHandlerName="BILLRowChangeEventHandler" msprop:Generator_RowDeletedName="BILLRowDeleted" msprop:Generator_UserTableName="BILL" msprop:Generator_RowChangedName="BILLRowChanged" msprop:Generator_RowEvArgName="BILLRowChangeEvent" msprop:Generator_RowClassName="BILLRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillId" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnBillId" msprop:Generator_ColumnPropNameInRow="BillId" msprop:Generator_ColumnPropNameInTable="BillIdColumn" msprop:Generator_UserColumnName="BillId" type="xs:int" />
              <xs:element name="DateTime" msprop:Generator_ColumnVarNameInTable="columnDateTime" msprop:Generator_ColumnPropNameInRow="DateTime" msprop:Generator_ColumnPropNameInTable="DateTimeColumn" msprop:Generator_UserColumnName="DateTime" type="xs:dateTime" />
              <xs:element name="OdometerReading" msprop:Generator_ColumnVarNameInTable="columnOdometerReading" msprop:Generator_ColumnPropNameInRow="OdometerReading" msprop:Generator_ColumnPropNameInTable="OdometerReadingColumn" msprop:Generator_UserColumnName="OdometerReading" type="xs:double" />
              <xs:element name="PaymentMethod" msprop:Generator_ColumnVarNameInTable="columnPaymentMethod" msprop:Generator_ColumnPropNameInRow="PaymentMethod" msprop:Generator_ColumnPropNameInTable="PaymentMethodColumn" msprop:Generator_UserColumnName="PaymentMethod">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreditCardNo" msprop:Generator_ColumnVarNameInTable="columnCreditCardNo" msprop:Generator_ColumnPropNameInRow="CreditCardNo" msprop:Generator_ColumnPropNameInTable="CreditCardNoColumn" msprop:Generator_UserColumnName="CreditCardNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BOOKING" msprop:Generator_TableClassName="BOOKINGDataTable" msprop:Generator_TableVarName="tableBOOKING" msprop:Generator_TablePropName="BOOKING" msprop:Generator_RowDeletingName="BOOKINGRowDeleting" msprop:Generator_RowChangingName="BOOKINGRowChanging" msprop:Generator_RowEvHandlerName="BOOKINGRowChangeEventHandler" msprop:Generator_RowDeletedName="BOOKINGRowDeleted" msprop:Generator_UserTableName="BOOKING" msprop:Generator_RowChangedName="BOOKINGRowChanged" msprop:Generator_RowEvArgName="BOOKINGRowChangeEvent" msprop:Generator_RowClassName="BOOKINGRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Booking_x0020_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnBooking_ID" msprop:Generator_ColumnPropNameInRow="Booking_ID" msprop:Generator_ColumnPropNameInTable="Booking_IDColumn" msprop:Generator_UserColumnName="Booking ID" type="xs:int" />
              <xs:element name="Departure_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnDeparture_Date" msprop:Generator_ColumnPropNameInRow="Departure_Date" msprop:Generator_ColumnPropNameInTable="Departure_DateColumn" msprop:Generator_UserColumnName="Departure Date" type="xs:dateTime" />
              <xs:element name="Memb_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnMemb_Name" msprop:Generator_ColumnPropNameInRow="Memb_Name" msprop:Generator_ColumnPropNameInTable="Memb_NameColumn" msprop:Generator_UserColumnName="Memb Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="91" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Department" msprop:Generator_ColumnVarNameInTable="columnDepartment" msprop:Generator_ColumnPropNameInRow="Department" msprop:Generator_ColumnPropNameInTable="DepartmentColumn" msprop:Generator_UserColumnName="Department">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Vehicle" msprop:Generator_ColumnVarNameInTable="columnVehicle" msprop:Generator_ColumnPropNameInRow="Vehicle" msprop:Generator_ColumnPropNameInTable="VehicleColumn" msprop:Generator_UserColumnName="Vehicle">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="93" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Dest_x0020_Address" msprop:Generator_ColumnVarNameInTable="columnDest_Address" msprop:Generator_ColumnPropNameInRow="Dest_Address" msprop:Generator_ColumnPropNameInTable="Dest_AddressColumn" msprop:Generator_UserColumnName="Dest Address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Dest_x0020_Postcode" msprop:Generator_ColumnVarNameInTable="columnDest_Postcode" msprop:Generator_ColumnPropNameInRow="Dest_Postcode" msprop:Generator_ColumnPropNameInTable="Dest_PostcodeColumn" msprop:Generator_UserColumnName="Dest Postcode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Clerk_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnClerk_Name" msprop:Generator_ColumnPropNameInRow="Clerk_Name" msprop:Generator_ColumnPropNameInTable="Clerk_NameColumn" msprop:Generator_UserColumnName="Clerk Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="91" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CHECKOUT" msprop:Generator_TableClassName="CHECKOUTDataTable" msprop:Generator_TableVarName="tableCHECKOUT" msprop:Generator_TablePropName="CHECKOUT" msprop:Generator_RowDeletingName="CHECKOUTRowDeleting" msprop:Generator_RowChangingName="CHECKOUTRowChanging" msprop:Generator_RowEvHandlerName="CHECKOUTRowChangeEventHandler" msprop:Generator_RowDeletedName="CHECKOUTRowDeleted" msprop:Generator_UserTableName="CHECKOUT" msprop:Generator_RowChangedName="CHECKOUTRowChanged" msprop:Generator_RowEvArgName="CHECKOUTRowChangeEvent" msprop:Generator_RowClassName="CHECKOUTRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CheckOutId" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCheckOutId" msprop:Generator_ColumnPropNameInRow="CheckOutId" msprop:Generator_ColumnPropNameInTable="CheckOutIdColumn" msprop:Generator_UserColumnName="CheckOutId" type="xs:int" />
              <xs:element name="EMPLOYEE_EmployeeId" msprop:Generator_ColumnVarNameInTable="columnEMPLOYEE_EmployeeId" msprop:Generator_ColumnPropNameInRow="EMPLOYEE_EmployeeId" msprop:Generator_ColumnPropNameInTable="EMPLOYEE_EmployeeIdColumn" msprop:Generator_UserColumnName="EMPLOYEE_EmployeeId" type="xs:int" />
              <xs:element name="OdometerReading" msprop:Generator_ColumnVarNameInTable="columnOdometerReading" msprop:Generator_ColumnPropNameInRow="OdometerReading" msprop:Generator_ColumnPropNameInTable="OdometerReadingColumn" msprop:Generator_UserColumnName="OdometerReading" type="xs:double" />
              <xs:element name="DateStart" msprop:Generator_ColumnVarNameInTable="columnDateStart" msprop:Generator_ColumnPropNameInRow="DateStart" msprop:Generator_ColumnPropNameInTable="DateStartColumn" msprop:Generator_UserColumnName="DateStart" type="xs:dateTime" />
              <xs:element name="DateEnd" msprop:Generator_ColumnVarNameInTable="columnDateEnd" msprop:Generator_ColumnPropNameInRow="DateEnd" msprop:Generator_ColumnPropNameInTable="DateEndColumn" msprop:Generator_UserColumnName="DateEnd" type="xs:dateTime" />
              <xs:element name="FuelPurchasedLitres" msprop:Generator_ColumnVarNameInTable="columnFuelPurchasedLitres" msprop:Generator_ColumnPropNameInRow="FuelPurchasedLitres" msprop:Generator_ColumnPropNameInTable="FuelPurchasedLitresColumn" msprop:Generator_UserColumnName="FuelPurchasedLitres" type="xs:double" minOccurs="0" />
              <xs:element name="CreditCardNo" msprop:Generator_ColumnVarNameInTable="columnCreditCardNo" msprop:Generator_ColumnPropNameInRow="CreditCardNo" msprop:Generator_ColumnPropNameInTable="CreditCardNoColumn" msprop:Generator_UserColumnName="CreditCardNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BILL_BillId" msprop:Generator_ColumnVarNameInTable="columnBILL_BillId" msprop:Generator_ColumnPropNameInRow="BILL_BillId" msprop:Generator_ColumnPropNameInTable="BILL_BillIdColumn" msprop:Generator_UserColumnName="BILL_BillId" type="xs:int" />
              <xs:element name="BOOKING_BookingId" msprop:Generator_ColumnVarNameInTable="columnBOOKING_BookingId" msprop:Generator_ColumnPropNameInRow="BOOKING_BookingId" msprop:Generator_ColumnPropNameInTable="BOOKING_BookingIdColumn" msprop:Generator_UserColumnName="BOOKING_BookingId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DEPARTMENT" msprop:Generator_TableClassName="DEPARTMENTDataTable" msprop:Generator_TableVarName="tableDEPARTMENT" msprop:Generator_TablePropName="DEPARTMENT" msprop:Generator_RowDeletingName="DEPARTMENTRowDeleting" msprop:Generator_RowChangingName="DEPARTMENTRowChanging" msprop:Generator_RowEvHandlerName="DEPARTMENTRowChangeEventHandler" msprop:Generator_RowDeletedName="DEPARTMENTRowDeleted" msprop:Generator_UserTableName="DEPARTMENT" msprop:Generator_RowChangedName="DEPARTMENTRowChanged" msprop:Generator_RowEvArgName="DEPARTMENTRowChangeEvent" msprop:Generator_RowClassName="DEPARTMENTRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DepartmentId" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnDepartmentId" msprop:Generator_ColumnPropNameInRow="DepartmentId" msprop:Generator_ColumnPropNameInTable="DepartmentIdColumn" msprop:Generator_UserColumnName="DepartmentId" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EMPLOYEE" msprop:Generator_TableClassName="EMPLOYEEDataTable" msprop:Generator_TableVarName="tableEMPLOYEE" msprop:Generator_TablePropName="EMPLOYEE" msprop:Generator_RowDeletingName="EMPLOYEERowDeleting" msprop:Generator_RowChangingName="EMPLOYEERowChanging" msprop:Generator_RowEvHandlerName="EMPLOYEERowChangeEventHandler" msprop:Generator_RowDeletedName="EMPLOYEERowDeleted" msprop:Generator_UserTableName="EMPLOYEE" msprop:Generator_RowChangedName="EMPLOYEERowChanged" msprop:Generator_RowEvArgName="EMPLOYEERowChangeEvent" msprop:Generator_RowClassName="EMPLOYEERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_UserColumnName="Surname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Firstname" msprop:Generator_ColumnVarNameInTable="columnFirstname" msprop:Generator_ColumnPropNameInRow="Firstname" msprop:Generator_ColumnPropNameInTable="FirstnameColumn" msprop:Generator_UserColumnName="Firstname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email_x0020_address" msprop:Generator_ColumnVarNameInTable="columnEmail_address" msprop:Generator_ColumnPropNameInRow="Email_address" msprop:Generator_ColumnPropNameInTable="Email_addressColumn" msprop:Generator_UserColumnName="Email address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contact_x0020_number" msprop:Generator_ColumnVarNameInTable="columnContact_number" msprop:Generator_ColumnPropNameInRow="Contact_number" msprop:Generator_ColumnPropNameInTable="Contact_numberColumn" msprop:Generator_UserColumnName="Contact number">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Department" msprop:Generator_ColumnVarNameInTable="columnDepartment" msprop:Generator_ColumnPropNameInRow="Department" msprop:Generator_ColumnPropNameInTable="DepartmentColumn" msprop:Generator_UserColumnName="Department">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INVENTORY" msprop:Generator_TableClassName="INVENTORYDataTable" msprop:Generator_TableVarName="tableINVENTORY" msprop:Generator_TablePropName="INVENTORY" msprop:Generator_RowDeletingName="INVENTORYRowDeleting" msprop:Generator_RowChangingName="INVENTORYRowChanging" msprop:Generator_RowEvHandlerName="INVENTORYRowChangeEventHandler" msprop:Generator_RowDeletedName="INVENTORYRowDeleted" msprop:Generator_UserTableName="INVENTORY" msprop:Generator_RowChangedName="INVENTORYRowChanged" msprop:Generator_RowEvArgName="INVENTORYRowChangeEvent" msprop:Generator_RowClassName="INVENTORYRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PartId" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPartId" msprop:Generator_ColumnPropNameInRow="PartId" msprop:Generator_ColumnPropNameInTable="PartIdColumn" msprop:Generator_UserColumnName="PartId" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Qty" msprop:Generator_ColumnVarNameInTable="columnQty" msprop:Generator_ColumnPropNameInRow="Qty" msprop:Generator_ColumnPropNameInTable="QtyColumn" msprop:Generator_UserColumnName="Qty" type="xs:int" />
              <xs:element name="LastOrder" msprop:Generator_ColumnVarNameInTable="columnLastOrder" msprop:Generator_ColumnPropNameInRow="LastOrder" msprop:Generator_ColumnPropNameInTable="LastOrderColumn" msprop:Generator_UserColumnName="LastOrder" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MAINTENANCE" msprop:Generator_TableClassName="MAINTENANCEDataTable" msprop:Generator_TableVarName="tableMAINTENANCE" msprop:Generator_TablePropName="MAINTENANCE" msprop:Generator_RowDeletingName="MAINTENANCERowDeleting" msprop:Generator_RowChangingName="MAINTENANCERowChanging" msprop:Generator_RowEvHandlerName="MAINTENANCERowChangeEventHandler" msprop:Generator_RowDeletedName="MAINTENANCERowDeleted" msprop:Generator_UserTableName="MAINTENANCE" msprop:Generator_RowChangedName="MAINTENANCERowChanged" msprop:Generator_RowEvArgName="MAINTENANCERowChangeEvent" msprop:Generator_RowClassName="MAINTENANCERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaintenanceId" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnMaintenanceId" msprop:Generator_ColumnPropNameInRow="MaintenanceId" msprop:Generator_ColumnPropNameInTable="MaintenanceIdColumn" msprop:Generator_UserColumnName="MaintenanceId" type="xs:int" />
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" />
              <xs:element name="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" msprop:Generator_UserColumnName="EndDate" type="xs:dateTime" />
              <xs:element name="VEHICLE_VahicleId" msprop:Generator_ColumnVarNameInTable="columnVEHICLE_VahicleId" msprop:Generator_ColumnPropNameInRow="VEHICLE_VahicleId" msprop:Generator_ColumnPropNameInTable="VEHICLE_VahicleIdColumn" msprop:Generator_UserColumnName="VEHICLE_VahicleId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MAINTENANCE_DETAILS" msprop:Generator_TableClassName="MAINTENANCE_DETAILSDataTable" msprop:Generator_TableVarName="tableMAINTENANCE_DETAILS" msprop:Generator_TablePropName="MAINTENANCE_DETAILS" msprop:Generator_RowDeletingName="MAINTENANCE_DETAILSRowDeleting" msprop:Generator_RowChangingName="MAINTENANCE_DETAILSRowChanging" msprop:Generator_RowEvHandlerName="MAINTENANCE_DETAILSRowChangeEventHandler" msprop:Generator_RowDeletedName="MAINTENANCE_DETAILSRowDeleted" msprop:Generator_UserTableName="MAINTENANCE_DETAILS" msprop:Generator_RowChangedName="MAINTENANCE_DETAILSRowChanged" msprop:Generator_RowEvArgName="MAINTENANCE_DETAILSRowChangeEvent" msprop:Generator_RowClassName="MAINTENANCE_DETAILSRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MAINTENANCE_MaintenanceId" msprop:Generator_ColumnVarNameInTable="columnMAINTENANCE_MaintenanceId" msprop:Generator_ColumnPropNameInRow="MAINTENANCE_MaintenanceId" msprop:Generator_ColumnPropNameInTable="MAINTENANCE_MaintenanceIdColumn" msprop:Generator_UserColumnName="MAINTENANCE_MaintenanceId" type="xs:int" />
              <xs:element name="ItemPerformed" msprop:Generator_ColumnVarNameInTable="columnItemPerformed" msprop:Generator_ColumnPropNameInRow="ItemPerformed" msprop:Generator_ColumnPropNameInTable="ItemPerformedColumn" msprop:Generator_UserColumnName="ItemPerformed" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="INVENTORY_PartId" msprop:Generator_ColumnVarNameInTable="columnINVENTORY_PartId" msprop:Generator_ColumnPropNameInRow="INVENTORY_PartId" msprop:Generator_ColumnPropNameInTable="INVENTORY_PartIdColumn" msprop:Generator_UserColumnName="INVENTORY_PartId" type="xs:int" />
              <xs:element name="EMPLOYEE_EmployeeId" msprop:Generator_ColumnVarNameInTable="columnEMPLOYEE_EmployeeId" msprop:Generator_ColumnPropNameInRow="EMPLOYEE_EmployeeId" msprop:Generator_ColumnPropNameInTable="EMPLOYEE_EmployeeIdColumn" msprop:Generator_UserColumnName="EMPLOYEE_EmployeeId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VEHICLE" msprop:Generator_TableClassName="VEHICLEDataTable" msprop:Generator_TableVarName="tableVEHICLE" msprop:Generator_TablePropName="VEHICLE" msprop:Generator_RowDeletingName="VEHICLERowDeleting" msprop:Generator_RowChangingName="VEHICLERowChanging" msprop:Generator_RowEvHandlerName="VEHICLERowChangeEventHandler" msprop:Generator_RowDeletedName="VEHICLERowDeleted" msprop:Generator_UserTableName="VEHICLE" msprop:Generator_RowChangedName="VEHICLERowChanged" msprop:Generator_RowEvArgName="VEHICLERowChangeEvent" msprop:Generator_RowClassName="VEHICLERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VahicleId" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVahicleId" msprop:Generator_ColumnPropNameInRow="VahicleId" msprop:Generator_ColumnPropNameInTable="VahicleIdColumn" msprop:Generator_UserColumnName="VahicleId" type="xs:int" />
              <xs:element name="RegNo" msprop:Generator_ColumnVarNameInTable="columnRegNo" msprop:Generator_ColumnPropNameInRow="RegNo" msprop:Generator_ColumnPropNameInTable="RegNoColumn" msprop:Generator_UserColumnName="RegNo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MileAge" msprop:Generator_ColumnVarNameInTable="columnMileAge" msprop:Generator_ColumnPropNameInRow="MileAge" msprop:Generator_ColumnPropNameInTable="MileAgeColumn" msprop:Generator_UserColumnName="MileAge" type="xs:float" />
              <xs:element name="LitresFuel" msprop:Generator_ColumnVarNameInTable="columnLitresFuel" msprop:Generator_ColumnPropNameInRow="LitresFuel" msprop:Generator_ColumnPropNameInTable="LitresFuelColumn" msprop:Generator_UserColumnName="LitresFuel" type="xs:float" />
              <xs:element name="MileAgeRate" msprop:Generator_ColumnVarNameInTable="columnMileAgeRate" msprop:Generator_ColumnPropNameInRow="MileAgeRate" msprop:Generator_ColumnPropNameInTable="MileAgeRateColumn" msprop:Generator_UserColumnName="MileAgeRate" type="xs:float" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BILL" />
      <xs:field xpath="mstns:BillId" />
    </xs:unique>
    <xs:unique name="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BOOKING" />
      <xs:field xpath="mstns:Booking_x0020_ID" />
    </xs:unique>
    <xs:unique name="CHECKOUT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CHECKOUT" />
      <xs:field xpath="mstns:CheckOutId" />
    </xs:unique>
    <xs:unique name="DEPARTMENT_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:DEPARTMENT" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="DEPARTMENT_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DEPARTMENT" />
      <xs:field xpath="mstns:DepartmentId" />
    </xs:unique>
    <xs:unique name="EMPLOYEE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EMPLOYEE" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="EMPLOYEE_Constraint2" msdata:ConstraintName="Constraint2">
      <xs:selector xpath=".//mstns:EMPLOYEE" />
      <xs:field xpath="mstns:Email_x0020_address" />
    </xs:unique>
    <xs:unique name="Constraint3">
      <xs:selector xpath=".//mstns:EMPLOYEE" />
      <xs:field xpath="mstns:Contact_x0020_number" />
    </xs:unique>
    <xs:unique name="INVENTORY_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INVENTORY" />
      <xs:field xpath="mstns:PartId" />
    </xs:unique>
    <xs:unique name="MAINTENANCE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MAINTENANCE" />
      <xs:field xpath="mstns:MaintenanceId" />
    </xs:unique>
    <xs:unique name="MAINTENANCE_DETAILS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MAINTENANCE_DETAILS" />
      <xs:field xpath="mstns:MAINTENANCE_MaintenanceId" />
    </xs:unique>
    <xs:unique name="VEHICLE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VEHICLE" />
      <xs:field xpath="mstns:VahicleId" />
    </xs:unique>
    <xs:unique name="VEHICLE_Constraint2" msdata:ConstraintName="Constraint2">
      <xs:selector xpath=".//mstns:VEHICLE" />
      <xs:field xpath="mstns:RegNo" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="fk_CHECKOUT_BILL1" msdata:parent="BILL" msdata:child="CHECKOUT" msdata:parentkey="BillId" msdata:childkey="BILL_BillId" msprop:Generator_UserChildTable="CHECKOUT" msprop:Generator_ChildPropName="GetCHECKOUTRows" msprop:Generator_UserRelationName="fk_CHECKOUT_BILL1" msprop:Generator_ParentPropName="BILLRow" msprop:Generator_RelationVarName="relationfk_CHECKOUT_BILL1" msprop:Generator_UserParentTable="BILL" />
      <msdata:Relationship name="fk_MAINTENANCE_DETAILS_INVENTORY1" msdata:parent="INVENTORY" msdata:child="MAINTENANCE_DETAILS" msdata:parentkey="PartId" msdata:childkey="INVENTORY_PartId" msprop:Generator_UserChildTable="MAINTENANCE_DETAILS" msprop:Generator_ChildPropName="GetMAINTENANCE_DETAILSRows" msprop:Generator_UserRelationName="fk_MAINTENANCE_DETAILS_INVENTORY1" msprop:Generator_ParentPropName="INVENTORYRow" msprop:Generator_RelationVarName="relationfk_MAINTENANCE_DETAILS_INVENTORY1" msprop:Generator_UserParentTable="INVENTORY" />
      <msdata:Relationship name="fk_MAINTENANCE_DETAILS_MAINTENANCE1" msdata:parent="MAINTENANCE" msdata:child="MAINTENANCE_DETAILS" msdata:parentkey="MaintenanceId" msdata:childkey="MAINTENANCE_MaintenanceId" msprop:Generator_UserChildTable="MAINTENANCE_DETAILS" msprop:Generator_ChildPropName="GetMAINTENANCE_DETAILSRows" msprop:Generator_UserRelationName="fk_MAINTENANCE_DETAILS_MAINTENANCE1" msprop:Generator_ParentPropName="MAINTENANCERow" msprop:Generator_RelationVarName="relationfk_MAINTENANCE_DETAILS_MAINTENANCE1" msprop:Generator_UserParentTable="MAINTENANCE" />
      <msdata:Relationship name="fk_MAINTENANCE_VEHICLE1" msdata:parent="VEHICLE" msdata:child="MAINTENANCE" msdata:parentkey="VahicleId" msdata:childkey="VEHICLE_VahicleId" msprop:Generator_UserChildTable="MAINTENANCE" msprop:Generator_ChildPropName="GetMAINTENANCERows" msprop:Generator_UserRelationName="fk_MAINTENANCE_VEHICLE1" msprop:Generator_RelationVarName="relationfk_MAINTENANCE_VEHICLE1" msprop:Generator_UserParentTable="VEHICLE" msprop:Generator_ParentPropName="VEHICLERow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>